package com.example.warehousems.dao;

import com.example.warehousems.dao.model.StorageBuffer;
import com.example.warehousems.dao.model.StorageCoKey;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface StorageBufferRepository extends JpaRepository<StorageBuffer, StorageCoKey> {
    @Query("select count(s) from StorageBuffer s where s.status = 0")
    float getStorageBufferCount();
    @Query("select count(s) from StorageBuffer s where s.status = 1")
    float getUsedStorageBufferCount();
}
